Attribute | Description | Physical Name | Domain | Data Type | Foreign Key Table |
CampaignID (PK) | Token ID for a Campaign | ID_CMPGN | Identity | integer | |
CampaignName | Business name for a Campagin | NM_CMPGN | DescriptionShort | varchar(255) | |
EffectiveDateTime | Date a Campaign begins and becomes effective. | DT_EF | EffectiveDateTime | datetime | |
ExpirationDateTime | Date a campaign ends and is no longer in effect. | DT_EP | ExpirationDateTime | datetime | |
CampaignStatusCode | Indicates current status of a Campaign Example values include: A - Active I - Inactive P - Pending (set up but not implemented) C - Canceled | CD_STS_CMPGN | Code2Status | char(2) | |
BusinessDevelopmentProgram | The name of an overarching program to acquire new customers, retain and grow sales from existing customers and reactivate in active customers. | ID_BSN_DVLPMNT_PRGM | Name | varchar(40) | |